How to get the degree of crystallinity:

1) measure an amorphous and a crystalline sample.

2) scale the crystalline curve (divide or multiply by a constant) to get the regions away from the crystalline peak to roughly match. There will be excess intensity at low-q associated with small angle scattering from the crystals. (If you subtract the amorphous curve from the crystalline you wil get just the crystalline curve that can be used to deterimine the full width at half height for the Scherrer analysis.)

i) Create a new column that is crystalline times a constant that is in a cell (use $H$5 for a fixed value to multiply all of the cells by). Plot the amorphous and scaled crystalline curves on the same plot in excel.

ii) Change both to lines with no points so you can see the regions of overlap.

iii) Change the constant so that you get the overlap described above by trial and error.

3) Calculate Iq^2 for the amorphous and scaled crystalline curves.

4) Sum these two columns to create a value for the interal A and C.

5) The degree of crystallinity is (C-A)/C. This should be a number between 0 and 1.

An excel sheet where some of this is done can be found at: Excel Sheet